package Hibernate.ManytoOne.Test;

import java.util.HashSet;

import org.hibernate.Session;

public class Main
	{

		public static void main(String[] args) throws Exception
			{
				HibernateUtil hibernateUtil = new HibernateUtil();
				// hibernateUtil
				// .executeSQLCommand("create table speakers (uid int, firstName varchar,lastName varchar, event_id int);");
				// hibernateUtil
				// .executeSQLCommand("create table locations (uid int, name varchar, address varchar,  event_id int);");
				// hibernateUtil
				// .executeSQLCommand("create table attendees (uid int, firstName varchar, lastName varchar,  event_id int);");
				// hibernateUtil
				// .executeSQLCommand("create table events (uid int , name varchar, start_date date, duration integer,location_id int);");

				Session session = hibernateUtil.getSession();

				Event e = new Event();
				e.setName("testSave");
				Location l = new Location();
				l.setName("building 1");
				e.setLocation(l);
				e.setSpeakers(new HashSet());
				e.getSpeakers().add(new Speaker("John", "Doe"));

				e.setAttendees(new HashSet());
				e.getAttendees().add(new Attendee("John", "Smith"));

				// session.save(l);
				session.save(e);
				// session.flush();

				session.close();
				hibernateUtil.checkData("select * from events");
				hibernateUtil.checkData("select * from speakers");
				hibernateUtil.checkData("select * from locations");
				hibernateUtil.checkData("select * from attendees");
			}
	}